﻿--市
CREATE proc [dbo].[proc_City_GetList]
(
	@pid int
)
As
Begin
	If @pid=0
		Select Id,Title,PId,[Level] From [City] Order By Pid,Id
	Else
		Select Id,Title,PId,[Level] From [City] Where pid=@pid Order By Id
End